/****** Delete data from DB before insert****/

delete from [dbo].[PassengerServices];
delete from [dbo].[Tickets];
delete from [dbo].[Passengers];
delete from [dbo].[Titles];
delete from [dbo].[Bookings];
delete from [dbo].[services];
delete from [dbo].[servicecategories];
delete from [dbo].[FlightPrices];
delete from [dbo].[FlightSeats];
delete from [dbo].[Flights];
delete from [dbo].[aircraftSeats];
delete from [dbo].[seatTypes];
delete from [dbo].[aircrafts];
delete from [dbo].[terminals];
delete from [dbo].[airports];
delete from [dbo].[cities];
delete from [dbo].[countries];
delete from [dbo].[CardTypes];
delete from [dbo].[PaymentMethods];
delete from [dbo].[Trips];


DBCC CHECKIDENT([aircraftSeats], RESEED, 0)
DBCC CHECKIDENT([aircrafts], RESEED, 0)
DBCC CHECKIDENT([Bookings], RESEED, 0)
DBCC CHECKIDENT([Flights], RESEED, 0)
DBCC CHECKIDENT([FlightSeats], RESEED, 0)

/****** Object:  Table [dbo].[countries] ******/

INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('CN','CHINA');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('SG','SINGAPORE');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('MY','MALAYSIA');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('ID','INDONESIA');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('HK','HONG KONG');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('IN','INDIA');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('AU','AUSTRALIA');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('JP','JAPAN');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('VN','VIET NAM');
INSERT INTO [dbo].[countries] ([countryCode],[countryName]) VALUES ('PH','PHILIPPINES');

/****** Object:  Table [dbo].[cities] ******/

INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('SHA','CN', 'SHANG HAI');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('BJS','CN', 'BEI JING');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('SIN','SG', 'SINGAPORE');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('KUL','MY', 'KUALA LUMPUR');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('DPS','ID', 'Denpasar, Bali');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('HKG','HK', 'HONG KONG');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('BOM','IN', 'MUMBAI');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('SYD','AU', 'SYDNEY');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('OSA','JP', 'OSAKA');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('HAN','VN', 'Hanoi');
INSERT INTO [dbo].[cities] ([cityCode],[countryCode],[cityName]) VALUES ('MNL','PH', 'Manila');



/****** Object:  Table [dbo].[airports]******/

INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('PVG','SHA','Pu Dong');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('SHA','SHA','Hongqiao');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('PEK','BJS','Beijing Capital Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('SIN','SIN','Changi');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('KUL','KUL','Kuala Lumpur Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('DPS','DPS','Ngurah Rai Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('HKG','HKG','Hong Kong Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('BOM','BOM','Sahar Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('SWZ','SYD','Sydney West');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('KIX','OSA','Kansai Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('HAN','HAN','Noibai Int.');
INSERT INTO [dbo].[airports] ([airportCode],[cityCode],[airportName]) VALUES ('MNL','MNL','Ninoy Aquino Int.');


/****** Object:  Table [dbo].[terminals]******/

INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('PVG1' ,'PVG' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('PVG3' ,'PVG' ,'Terminal Three');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('SHA1' ,'SHA' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('PEK2' ,'PEK' ,'Terminal Two');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('SIN1' ,'SIN' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('SIN3' ,'SIN' ,'Terminal Three');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('KUL3' ,'KUL' ,'Terminal Three');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('DPS1' ,'DPS' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('HKG1' ,'HKG' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('HKG2' ,'HKG' ,'Terminal Two');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('BOM2' ,'BOM' ,'Terminal Two');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('SWZ1' ,'SWZ' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('KIX3' ,'KIX' ,'Terminal Three');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('HAN1' ,'HAN' ,'Terminal One');
INSERT INTO [dbo].[terminals] ([terminalCode],[airportCode],[terminalDescription]) VALUES ('MNL1' ,'MNL' ,'Terminal One');


/****** Object:  Table [dbo].[servicecategories]******/

INSERT INTO [dbo].[servicecategories] ([servicecategoryCode],[servicecategoryDescription]) VALUES ('INSU','Insurance');
INSERT INTO [dbo].[servicecategories] ([servicecategoryCode],[servicecategoryDescription]) VALUES ('LUGG','Luggage');
INSERT INTO [dbo].[servicecategories] ([servicecategoryCode],[servicecategoryDescription]) VALUES ('MEAL','Meal');

/****** Object:  Table [dbo].[services]******/

INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('INTG','INSU','Travel Guard','15');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('INAA','INSU','AIA','15');

INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PBAA','LUGG','Regular- up to 15kg','16');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PBAB','LUGG','Medium - up to 30kg','25');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PBAC','LUGG','Large - up to 45kg','40');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PBAD','LUGG','Xtra L - up to 60kg','50');

INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('VRCB','MEAL','Vege Rice Combo','4');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('FRCB','MEAL','Fried Rice Combo','5');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('HDCB','MEAL','Hotdog Combo','3');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PZCB','MEAL','Premium Pizza Combo','10');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('SBCB','MEAL','Spaghetti Combo','5');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('PCCB','MEAL','Pancake Combo','6');
INSERT INTO [dbo].[services] ([serviceCode],[servicecategoryCode],[serviceDescription],[price]) VALUES ('SFCB','MEAL','Seafood Combo','10');


/****** Object:  Table [dbo].[aircrafts]******/

INSERT INTO [dbo].[aircrafts] ([aircraftName],[totalRow],[totalCol],[totalSeat]) VALUES ('Airbus 320','5','7','24');
INSERT INTO [dbo].[aircrafts] ([aircraftName],[totalRow],[totalCol],[totalSeat]) VALUES ('Boeing 737','6','9','35');

/****** Object:  Table [dbo].[seatTypes]******/

INSERT INTO [dbo].[seatTypes]([seatTypeCode],[seatTypeDescription],[SeatForSelection]) VALUES('LV' ,'Lavatory', '0');
INSERT INTO [dbo].[seatTypes]([seatTypeCode],[seatTypeDescription],[SeatForSelection]) VALUES('RS' ,'Reserved', '0');
INSERT INTO [dbo].[seatTypes]([seatTypeCode],[seatTypeDescription],[SeatForSelection]) VALUES('EM' ,'Empty', '0');
INSERT INTO [dbo].[SeatTypes]([SeatTypeCode],[SeatTypeDescription],[SeatForSelection]) VALUES('BC' ,'Business Class', '1');
INSERT INTO [dbo].[SeatTypes]([SeatTypeCode],[SeatTypeDescription],[SeatForSelection]) VALUES('FC' ,'First Class', '1');
INSERT INTO [dbo].[SeatTypes]([SeatTypeCode],[SeatTypeDescription],[SeatForSelection]) VALUES('EC' ,'Economy Class','1');


/****** Object:  Table [dbo].[aircraftSeats]******/

INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint]) 
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','1L' ,'1','1','1','0','0');
	 
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','1L' ,'1','2','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','1L' ,'1','3','0','1','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EM','EM' ,'1','4','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','2L' ,'1','5','0','1','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','2L' ,'1','6','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'LV','2L' ,'1','7','1','0','0');
	 
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2A' ,'2','1','1','0',200);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2B' ,'2','2','0','0',200);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2C' ,'2','3','0','1',200);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EM','EM' ,'2','4','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2D' ,'2','5','0','1',200);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2E' ,'2','6','0','0',200);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'FC','2F' ,'2','7','1','0',200);
	 
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3A' ,'3','1','1','0',100);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3B' ,'3','2','0','0',100);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3C' ,'3','3','0','1',100);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EM','EM' ,'3','4','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3D' ,'3','5','0','1',100);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3E' ,'3','6','0','0',100);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'BC','3F' ,'3','7','1','0',100);
	 
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4A' ,'4','1','1','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4B' ,'4','2','0','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4C' ,'4','3','0','1',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EM','EM' ,'4','4','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4D' ,'4','5','0','1',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4E' ,'4','6','0','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','4F' ,'4','7','1','0',50);
	 
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5A' ,'5','1','1','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5B' ,'5','2','0','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5C' ,'5','3','0','1',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EM','EM' ,'5','4','0','0','0');
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5D' ,'5','5','0','1',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5E' ,'5','6','0','0',50);
INSERT INTO [dbo].[aircraftSeats] ([aircraftId],[seatTypeCode],[seatNo],[seatRow],[seatColumn],[isWindowSeat],[isAisleSeat],[rewardpoint])
     VALUES ((SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'EC','5F' ,'5','7','1','0',50);

/****** Object:  Table [dbo].[Trips]******/
INSERT INTO [dbo].[Trips]([TripCode],[TripDescription]) VALUES ('OneWayTrip','One Way Trip');
INSERT INTO [dbo].[Trips]([TripCode],[TripDescription]) VALUES ('RoundTrip','Round Trip');

/****** Object:  Table [dbo].[PaymentMethods]******/
INSERT INTO [dbo].[PaymentMethods]([PaymentMethodCode],[PaymentMethodDescription]) VALUES ('Credit','Credit Card');
INSERT INTO [dbo].[PaymentMethods]([PaymentMethodCode],[PaymentMethodDescription]) VALUES ('Debit','Debit Card');

/****** Object:  Table [dbo].[CardTypes]******/
INSERT INTO [dbo].[CardTypes]([CardTypeCode],[CardTypeDescription]) VALUES('Master','Master Card');
INSERT INTO [dbo].[CardTypes]([CardTypeCode],[CardTypeDescription]) VALUES('Visa','Visa');

/****** Object:  Table [dbo].[Titles]******/
INSERT INTO [dbo].[Titles] ([TitleCode] ,[TitleDescription]) VALUES('Miss','Miss');
INSERT INTO [dbo].[Titles] ([TitleCode] ,[TitleDescription]) VALUES('Mr','Mr');
INSERT INTO [dbo].[Titles] ([TitleCode] ,[TitleDescription]) VALUES('Mrs','Mrs');
INSERT INTO [dbo].[Titles] ([TitleCode] ,[TitleDescription]) VALUES('Ms','Ms');



	 
